package com.springcloud.client3tcc.web.dao;

import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

/**
 * @author liq
 * @Title: UserDao
 * @ProjectName lcn-demo
 * @Description: TODO
 * @date 2019-06-0409:15
 */
@Mapper
public interface UserDao {

    @Insert("INSERT INTO `user` (`username`, `password`, `name`,groupId) VALUES ( '${username}', '${password}', '${name}' ,  '${groupId}');")
    public int insert(@Param("name") String name, @Param("username") String username, @Param("password") String password, @Param("groupId") String groupId );


    @Insert("delete from user where groupId ='${groupId}'")
    public int delete(@Param("groupId") String groupId);
}
